<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Filter On Metric dialog box</title>
<link rel="stylesheet" href="default_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='default.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:disc; }
p.whs2 { margin-top:4.5pt; margin-bottom:4.5pt; }
p.whs3 { font-weight:bold; }
ol.whs4 { list-style:decimal; }
p.whs5 { margin-left:40px; margin-top:4.5pt; margin-bottom:4.5pt; }
p.whs6 { font-weight:bold; margin-left:0px; }
p.whs7 { margin-left:0px; }
p.whs8 { margin-left:0px; margin-top:4.5pt; margin-bottom:4.5pt; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs6 {margin-left:1pt; }";
  strNSS += "p.whs7 {margin-left:1pt; }";
  strNSS += "p.whs8 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying reports\nRetrieving specific data from sources: Filters\nFilter On Metric dialog box");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Filter On Metric dialog box</h1>
<p>A view filter restricts the amount of data displayed on the report and 
 provides you with a different view of the data. You can create a view 
 filter based on a rank range of values, or by defining a condition that 
 is based on any metric on your report. You must own the OLAP Services 
 product to create a view filter. For more details, see the <span style="font-style: italic;"><I>View 
 Filters</I></span> chapter in the <span style="font-style: italic;"><I>OLAP Services 
 Guide</I></span>.</p>
<p>&nbsp;</p>
<p>This topic provides details on each option in the Filter on Metric dialog 
 box, and steps to access the dialog box. It does not provide specific 
 steps to create a certain type of view filter.</p>
<ul type="disc" class="whs1">
	
<li class=p><p class="whs2">For 
 steps to create a view filter on a metric based on rank, see Creating 
 a view filter on a rank range of metric values.</p></li>
	
<li class=p><p class="whs2">For 
 steps to create a view filter on a metric based on a condition, see Creating 
 a view filter on a percentage range of metric values.</p></li>
</ul>
<p>&nbsp;</p>
<p>Use the Filter on Metric dialog box to create a filter on a selected 
 metric based on a rank range of metric values or on a condition. The view 
 filter on a rank range of metric values lets you to view analysis such 
 as the bottom 20 products in terms of profit margin while the view filter 
 based on a condition lets you to view analysis such as employees between 
 30% and 60% of tenure length with the company.</p>
<p class="whs3">&nbsp;</p>
<p class="whs3">Accessing the Filter on Metric dialog box</p>
<ol type="1" class="whs4">
	
<li class=p><p class="whs2">Run 
 the report in Grid View. </p></li>
	
<li class=p><p class="whs2">Right-click 
 a metric on the report and select <span style="font-weight: bold;"><B>Filter 
 On</B></span>.</p></li>
	
<li class=p><p class="whs2">Select 
 one of the following:</p></li>
	<ul type="disc" class="whs1">
		
<li class=p><p class="whs2"><span 
 style="font-weight: bold;"><B>Top N</B></span> to create a view filter based 
 on a rank range of metric values.</p></li>
	</ul>
</ol>
<ul>
<li style="list-style: disc;" type=disc class=p><p class="whs5"><span 
 style="font-weight: bold;"><B>Add Condition</B></span> to create a view filter 
 based on a condition. </p></li>
</ul>
<p class="whs5">The 
 Filter On Metric dialog box opens.</p>
<p class="whs6">&nbsp;</p>
<p class="whs6">Filter On menu options</p>
<p class="whs6">&nbsp;</p>
<p class="whs7">The Filter On menu displays options depending 
 on whether the selected metric already has a view filter or not. If the 
 selected metric has prior filtering conditions applied on it, the following 
 options are displayed:</p>
<ul type="disc" class="whs1">
	
<li class=p><p class="whs8"><span 
 style="font-weight: bold;"><B>Clear</B></span>: Clears the existing filtering 
 conditions for the selected metric.</p></li>
	
<li class=p><p class="whs8"><span 
 style="font-weight: bold;"><B>Top N</B></span>: Displays the Filter on Metric 
 dialog box to create a new filter by defining a rank based on the selected 
 metric. For steps, see 
<a href="Filtering_metrics_on_rank_and_percentage_ranges.htm">Creating 
 a filter on metric based on rank</a>.</p></li>
	
<li class=p><p class="whs8"><span 
 style="font-weight: bold;"><B>Edit Condition</B></span>: Displays the Filter 
 on Metric dialog box with the existing filter condition and lets you to 
 change the condition or add a new filtering condition.</p></li>
	
<li class=p><p class="whs8"><span 
 style="font-weight: bold;"><B>Add Condition</B></span>: Displays the Filter on 
 Metric dialog box to create a new filter by defining a condition based 
 on the selected metric. For steps, see 
<a href="Filtering_data_based_on_metrics.htm">Creating 
 a filter on metric based on a condition.</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
